package com.bjb.vr.common.mapper;

import com.bjb.vr.common.dto.UmsUserRole;
import com.bjb.vr.common.vo.PersonalInfoVo;
import com.bjb.vr.common.vo.UmsUserRoleVo;
import com.github.yulichang.base.MPJBaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author admin
 * @description 针对表【ums_user_role(用户和角色关联表)】的数据库操作Mapper
 * @createDate 2022-04-29 11:28:38
 * @Entity dto.UmsUserRole
 */
public interface UmsUserRoleMapper extends MPJBaseMapper<UmsUserRole> {

    List<UmsUserRoleVo> selectByCondition(@Param("userName") String userName, @Param("status") Integer status, @Param("roleId") String roleId);

    List<PersonalInfoVo> queryPersonalInfo(@Param("userName") String userName);

    void removeOldRole(@Param("oldUserId") Long oldUserId, @Param("roleId") Long roleId);

    void removeOldRole2(@Param("oldUserId") Long oldUserId);

    String queryRoleNameByUserId(@Param("userId") Long userId);
}




